<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
   "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/>
<head>
    <title>lua-cassandra documentation</title>
    <link rel="stylesheet" href="../ldoc.css" type="text/css" />
</head>
<body>

<div id="container">

<div id="product">
	<div id="product_logo"></div>
	<div id="product_name"><big><b></b></big></div>
	<div id="product_description"></div>
</div> <!-- id="product" -->


<div id="main">


<!-- Menu -->

<div id="navigation">
<br/>
<h1>lua-cassandra</h1>

<ul>
  <li><a href="../index.html">Index</a></li>
</ul>



<h2>Examples</h2>
<ul class="nowrap">
  <li><a href="../examples/authentication.lua.html">authentication.lua</a></li>
  <li><a href="../examples/batch.lua.html">batch.lua</a></li>
  <li><a href="../examples/intro.lua.html">intro.lua</a></li>
  <li><strong>pagination.lua</strong></li>
  <li><a href="../examples/ssl.lua.html">ssl.lua</a></li>
</ul>
<h2>Modules</h2>
<ul class="nowrap">
  <li><a href="../modules/cassandra.html">cassandra</a></li>
  <li><a href="../modules/resty.cassandra.cluster.html">resty.cassandra.cluster</a></li>
  <li><a href="../modules/resty.cassandra.policies.lb.dc_rr.html">resty.cassandra.policies.lb.dc_rr</a></li>
  <li><a href="../modules/resty.cassandra.policies.lb.req_dc_rr.html">resty.cassandra.policies.lb.req_dc_rr</a></li>
  <li><a href="../modules/resty.cassandra.policies.lb.req_rr.html">resty.cassandra.policies.lb.req_rr</a></li>
  <li><a href="../modules/resty.cassandra.policies.lb.rr.html">resty.cassandra.policies.lb.rr</a></li>
  <li><a href="../modules/resty.cassandra.policies.reconnection.const.html">resty.cassandra.policies.reconnection.const</a></li>
  <li><a href="../modules/resty.cassandra.policies.reconnection.exp.html">resty.cassandra.policies.reconnection.exp</a></li>
  <li><a href="../modules/resty.cassandra.policies.retry.simple.html">resty.cassandra.policies.retry.simple</a></li>
</ul>
<h2>Manual</h2>
<ul class="nowrap">
  <li><a href="../manual/README.md.html">README</a></li>
</ul>

</div>

<div id="content">

    <h2>pagination.lua</h2>
<pre>
<span class="comment">--------------------
</span><span class="comment">-- manual pagination
</span><span class="comment">--------------------
</span>
<span class="keyword">local</span> cassandra = <span class="global">require</span> <span class="string">"cassandra"</span>

<span class="keyword">local</span> client = <span class="global">assert</span>(cassandra.new {
  host = <span class="string">"127.0.0.1"</span>,
  keyspace = <span class="string">"my_keyspace"</span>
})

client:settimeout(<span class="number">1000</span>)

<span class="global">assert</span>(client:connect())

<span class="comment">-- assume 1190 rows in users table
</span>
<span class="comment">-- 1st page
</span><span class="keyword">local</span> rows_1 = <span class="global">assert</span>(client:execute(<span class="string">"SELECT * FROM users"</span>))
<span class="global">print</span>(#rows_1)                    <span class="comment">-- 1000 (default page_size)
</span><span class="global">print</span>(rows_1.meta.has_more_pages) <span class="comment">-- true
</span>
<span class="comment">-- 2nd page
</span><span class="keyword">local</span> rows_2 = <span class="global">assert</span>(client:execute(<span class="string">"SELECT * FROM users"</span>, <span class="keyword">nil</span>, {
  page_size = <span class="number">100</span>,
  paging_state = rows_1.meta.paging_state
}))
<span class="global">print</span>(#rows_2)                    <span class="comment">-- 100
</span><span class="global">print</span>(rows_2.meta.has_more_pages) <span class="comment">-- true
</span>
<span class="comment">-- 3rd, last page
</span><span class="keyword">local</span> rows_3 = <span class="global">assert</span>(client:execute(<span class="string">"SELECT * FROM users"</span>, <span class="keyword">nil</span>, {
  page_size = <span class="number">100</span>,
  paging_state = rows_2.meta.paging_state
}))
<span class="global">print</span>(#rows_3)                    <span class="comment">-- 90
</span><span class="global">print</span>(rows_3.meta.has_more_pages) <span class="comment">-- false
</span>
<span class="comment">-----------------------
</span><span class="comment">-- automated pagination
</span><span class="comment">-----------------------
</span>
<span class="keyword">for</span> rows, err, page <span class="keyword">in</span> client:iterate(<span class="string">"SELECT * FROM users"</span>) <span class="keyword">do</span>
  <span class="keyword">if</span> err <span class="keyword">then</span>
    <span class="global">error</span>(err)
  <span class="keyword">end</span>
  <span class="global">print</span>(page)
  <span class="global">print</span>(#rows)
<span class="keyword">end</span></pre>


</div> <!-- id="content" -->
</div> <!-- id="main" -->
<div id="about">
<i>generated by <a href="http://github.com/stevedonovan/LDoc">LDoc 1.4.6</a></i>
<i style="float:right;">Last updated 2022-05-20 11:10:11 </i>
</div> <!-- id="about" -->
</div> <!-- id="container" -->
</body>
</html>
